CallSheet ©1998 Charles Reed

Email: kidsnews@iname.com

Web: http://www.geocities.com/SiliconValley/Bay/9517/

What is CallSheet?

CallSheet allows you to input your telephone calls and internet connections in an easy format and then calculates your costs.

How do I use the sheet?

Quite simply all you need to do is input your time spent on-line into the relevant columns.

As this sheet is setup for South African tariffs, I hope you can modify it for your own country. I will explain how our phone system works so that you can understand how to modify CallSheet for your own country. Please email me a copy of your own CallSheet once you have modified this one and I will make it available for other users.

SA tariffs work on:

• Cost per unit - cents e.g. 38.6 per 3 minutes (Standard: 7am - 7pm) or 38.6 per 10 minutes (Cheap: 7pm - 7am) for e.g. a local call.
  (R1=100cents)

• Units - time in seconds for one charge
  e.g. 180 seconds (Std) or 600 seconds (Cheap) for a local call

• Distance - in kilometres from phone to number called e.g. Local calls are to any place as long as it is under 50km (Distance 1). National calls are then metered on the following distances:
  Distance 2: 50-100km
  Distance 3: 100-200km
  Distance 4: >200km

Using CallSheet

Below is a picture of CallSheet and information of the relevant columns.

(Text in quotes are for examples of how to input data - you don't need to type the quotes)

For the whole column

A Date

(Tip: To enter 10 September, just type "10 9" and then press Enter or an arrow key)

B Standard or Cheap rate - type "s" or "c"

C Distance - type "1", "2", "3" or "4"

1 = Call to distance 1

2 = Call to distance 2

3 = Call to distance 3

4 = Call to distance 4

D Hours

E Minutes

F Seconds

G Time in minutes - automatically calculated

H Cost of call for Standard rate - automatically calculated

I Cost of call for Cheap rate - automatically calculated

For specific cells

H2 Total cost of calls for Standard rate - automatically calculated

I2 Total cost of calls for Cheap rate - automatically calculated

C1 Total costs of all Standard and Cheap calls - automatically calculated

G1 Total amount in minutes of all calls - automatically calculated

I1 Total number of calls made - automatically calculated

Setting up CallSheet for your own use

Cell B2 Cost per unit in cents (or whatever your currency is!)

Columns J and K are formulae columns and as such shouldn't be edited (unless you understand the formulae and what they calculate!)

Columns L and M are where you input your units in seconds:

Standard Cheap Distance

L4 M4 0-50km

L5 M5 50-100km

L6 M6 100-200km

L7 M7 >200km

I have set up CallSheet for 50 entries, but you can add extra if you ned more. (Remember to unprotect and then re-protect the formulae areas once finished - saves you from deleting important calculations!)

CallSheet is a small spreadsheet I wrote for my own use. If you find it useful, please send me a postcard:
1 Lilyvale Gardens
7 Lilyvale Road
Pinetown 3610
KwaZulu Natal
South Africa

Tips, comments or ideas please email me at kidsnews@iname.com
Regards